CREATE TABLE [dbo].[Terms]
(
[TERMS_CODE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Terms_TERMS_CODE] DEFAULT (''),
[DESCRIPTION] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Terms_DESCRIPTION] DEFAULT (''),
[DISC_DAYS] [int] NOT NULL CONSTRAINT [DF_Terms_DISC_DAYS] DEFAULT ((0)),
[DISC_PERCENT] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Terms_DISC_PERCENT] DEFAULT ((0)),
[DUE_DAYS] [int] NOT NULL CONSTRAINT [DF_Terms_DUE_DAYS] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Terms] ADD CONSTRAINT [PK_Terms] PRIMARY KEY CLUSTERED ([TERMS_CODE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Terms] TO [IMIS]
GRANT SELECT ON  [dbo].[Terms] TO [IMIS]
GRANT INSERT ON  [dbo].[Terms] TO [IMIS]
GRANT DELETE ON  [dbo].[Terms] TO [IMIS]
GRANT UPDATE ON  [dbo].[Terms] TO [IMIS]
GO